Overview

Dataset info

Number of variables38
Number of observations104032
Missing cells1 (< 0.1%)
Duplicate rows118 (0.1%)
Total size in memory30.2 MiB
Average record size in memory304.0 B

Variables types

Numeric7
Categorical30
Boolean1
Date0
URL0
Text (Unique)0
Rejected0
Unsupported0

Warnings

Dataset has 118 (0.1%) duplicate rows Warning
CRASH_LOCN1 has a high cardinality: 11608 distinct values Warning
CRASH_DIST has 35316 (33.9%) zeros Zeros
CRASH_RP_SH has a high cardinality: 98 distinct values Warning
CRASH_LOCN2 has a high cardinality: 22302 distinct values Warning
CRASH_RP_DISP has 73052 (70.2%) zeros Zeros
CRASH_RP_RS has 76863 (73.9%) zeros Zeros

Variables

WEATHER_A
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Fine
78641
Light Rain
16582
Heavy Rain
 
4184
Other values (3)
 
4625
ValueCountFrequency (%) 
Fine 78641 75.6%
 
Light Rain 16582 15.9%
 
Heavy Rain 4184 4.0%
 
Unknown 2878 2.8%
 
Mist 1608 1.5%
 
Snow 139 0.1%
 
Max length10
Mean length5.280663642
Min length4
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

ROAD_WET
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Dry
75072
Wet
26966
Ice/ Snow
 
1059
ValueCountFrequency (%) 
Dry 75072 72.2%
 
Wet 26966 25.9%
 
Ice/ Snow 1059 1.0%
 
Unknown 935 0.9%
 
Max length9
Mean length3.097027838
Min length3
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

MULTI_VEH
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Multi vehicle
64548
Single vehicle
33596
Vehicle(s)+Pedestrian(s)
 
2867
Other values (5)
 
3021
ValueCountFrequency (%) 
Multi vehicle 64548 62.0%
 
Single vehicle 33596 32.3%
 
Vehicle(s)+Pedestrian(s) 2867 2.8%
 
Vehicle(s)+Cyclist(s) only 2578 2.5%
 
Vehicle(s)+multiple other types 232 0.2%
 
Cyclists only 159 0.2%
 
Cyclist(s)+Pedestrian(s) only 28 < 0.1%
 
Other 24 < 0.1%
 
Max length31
Mean length13.99083936
Min length5
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

CRASH_SEV
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
N
74247
M
22870
S
 
6052
ValueCountFrequency (%) 
N 74247 71.4%
 
M 22870 22.0%
 
S 6052 5.8%
 
F 863 0.8%
 
Max length1
Mean length1
Min length1
Contains digitsFalse
Contains spacesFalse
Contains charsTrue
Contains non-wordsFalse

TRAFFIC_CTRL
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
N/A
58949
Give Way Sign
18046
Nil
 
11610
Other values (4)
15427
ValueCountFrequency (%) 
N/A 58949 56.7%
 
Give Way Sign 18046 17.3%
 
Nil 11610 11.2%
 
Traffic Signal 9327 9.0%
 
Stop Sign 6089 5.9%
 
School Patrol 9 < 0.1%
 
Points Man 2 < 0.1%
 
Max length14
Mean length6.073044832
Min length3
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

NORTHING
Numeric

Distinct count70011
Unique (%)67.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean5646818.013
Minimum0
Maximum6189126
Zeros (%)0.1%
Mini histogram
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 2397228. 4794536.5 4795797.5 4826138.5 ... 6113000.5 6115053. 6128807. 6141593. 6189126. ], "bayesian blocks" binning strategy used)

Minimum 5 values

ValueCountFrequency (%) 
0 115 0.1%
 
4794456 1 < 0.1%
 
4794617 1 < 0.1%
 
4794760 1 < 0.1%
 
4794866 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
6189126 1 < 0.1%
 
6188959 1 < 0.1%
 
6183516 1 < 0.1%
 
6183467 1 < 0.1%
 
6182851 1 < 0.1%
 
ValueCountFrequency (%) 
0 115 0.1%
 
5912242 39 < 0.1%
 
5821420 39 < 0.1%
 
5919442 32 < 0.1%
 
5914776 30 < 0.1%
 
5824472 27 < 0.1%
 
5935924 26 < 0.1%
 
5900037 25 < 0.1%
 
5530873 24 < 0.1%
 
5915247 24 < 0.1%
 
Other values (70001) 103651 99.6%
 

Quantile statistics

Minimum0
5-th percentile4936081.7
Q15434922
Median5812603
Q35913488.5
95-th percentile5956944.95
Maximum6189126
Range6189126
Interquartile range478566.5

Descriptive statistics

Standard deviation375648.2255
Coef of variation0.06652387674
Kurtosis54.9271655
Mean5646818.013
MAD284300.149
Skewness-4.308731443
Sum5.874497716e+11
Variance1.411115893e+11
Memory size812.8 KiB

URBAN
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Urban
67504
Openroad
36528
ValueCountFrequency (%) 
Urban 67504 64.9%
 
Openroad 36528 35.1%
 
Max length8
Mean length6.053368194
Min length5
Contains digitsFalse
Contains spacesFalse
Contains charsTrue
Contains non-wordsFalse

HOLIDAY
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
None
98535
Christmas/New Year
 
2501
Easter
 
1319
Other values (2)
 
1677
ValueCountFrequency (%) 
None 98535 94.7%
 
Christmas/New Year 2501 2.4%
 
Easter 1319 1.3%
 
Queens Birthday 1035 1.0%
 
Labour Weekend 642 0.6%
 
Max length18
Mean length4.533076361
Min length4
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

CRASH_LOCN1
Categorical

Distinct count11608
Unique (%)11.2%
Missing (%)0.0%
Missing (n)0
SH 1N
 
9014
SH 2
 
3065
SH 1S
 
2589
Other values (11605)
89364
ValueCountFrequency (%) 
SH 1N 9014 8.7%
 
SH 2 3065 2.9%
 
SH 1S 2589 2.5%
 
SH 6 1679 1.6%
 
SH 3 1618 1.6%
 
GREAT SOUTH ROAD 1269 1.2%
 
SH 16 1105 1.1%
 
SH 20 713 0.7%
 
SH 5 618 0.6%
 
GREAT NORTH ROAD 612 0.6%
 
Other values (11598) 81750 78.6%
 
Max length25
Mean length10.57161258
Min length1
Contains digitsTrue
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

LIGHT
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Bright Sun
36881
Overcast
32672
Dark
29215
Other values (2)
 
5264
ValueCountFrequency (%) 
Bright Sun 36881 35.5%
 
Overcast 32672 31.4%
 
Dark 29215 28.1%
 
Twilight 5050 4.9%
 
Unknown 214 0.2%
 
Max length10
Mean length7.583666564
Min length4
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

ROAD_CHARACTER
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Unknown
99502
Bridge
 
2244
Motorway Ramp
 
2039
ValueCountFrequency (%) 
Unknown 99502 95.6%
 
Bridge 2244 2.2%
 
Motorway Ramp 2039 2.0%
 
Railway Crossing 247 0.2%
 
Max length16
Mean length7.11739657
Min length6
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

FLAT_HILL
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Flat
82461
Hill
20737
Unknown
 
834
ValueCountFrequency (%) 
Flat 82461 79.3%
 
Hill 20737 19.9%
 
Unknown 834 0.8%
 
Max length7
Mean length4.024050292
Min length4
Contains digitsFalse
Contains spacesFalse
Contains charsTrue
Contains non-wordsFalse

LG_REGION_DESC
Categorical

Distinct count15
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Auckland
36520
Waikato
12040
Wellington
10267
Other values (12)
45205
ValueCountFrequency (%) 
Auckland 36520 35.1%
 
Waikato 12040 11.6%
 
Wellington 10267 9.9%
 
Canterbury 9868 9.5%
 
Bay of Plenty 6303 6.1%
 
Manawatu/Wanganui 5664 5.4%
 
Otago 5386 5.2%
 
Northland 4456 4.3%
 
Hawkes Bay 3749 3.6%
 
Nelson/Marlborough 3159 3.0%
 
Other values (5) 6620 6.4%
 
Max length20
Mean length19.99945209
Min length1
Contains digitsTrue
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

CR_RD_SIDE_RD
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
1
99586
2
 
4444
0
 
1
(Missing)
 
1
ValueCountFrequency (%) 
1 99586 95.7%
 
2 4444 4.3%
 
0 1 < 0.1%
 
(Missing) 1 < 0.1%
 
Max length3
Mean length3
Min length3
Contains digitsTrue
Contains spacesFalse
Contains charsTrue
Contains non-wordsTrue

ROAD_CURVATURE
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Straight Road
74454
Moderate Curve
22648
Easy Curve
 
6094
Other values (2)
 
836
ValueCountFrequency (%) 
Straight Road 74454 71.6%
 
Moderate Curve 22648 21.8%
 
Easy Curve 6094 5.9%
 
Severe Curve 832 0.8%
 
Unknown 4 < 0.1%
 
Max length14
Mean length13.03373962
Min length7
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

INTSN_MIDBLOCK
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Mid Block
68094
Intersection
35938
ValueCountFrequency (%) 
Mid Block 68094 65.5%
 
Intersection 35938 34.5%
 
Max length12
Mean length10.0363542
Min length9
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

OUTDTD_LOCN_DESC
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Current location
104005
Outdated Location
 
26
0
 
1
ValueCountFrequency (%) 
Current location 104005 > 99.9%
 
Outdated Location 26 < 0.1%
 
0 1 < 0.1%
 
Max length17
Mean length16.00010574
Min length1
Contains digitsTrue
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

CRASH_DIST
Numeric

Distinct count567
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean197.0189942
Minimum0
Maximum15600
Zeros (%)33.9%
Mini histogram
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000e+00 2.500e+00 7.500e+00 1.750e+01 2.250e+01 ... 4.105e+03 5.155e+03 7.015e+03 8.845e+03 1.560e+04], "bayesian blocks" binning strategy used)

Minimum 5 values

ValueCountFrequency (%) 
0 35316 33.9%
 
5 139 0.1%
 
10 1553 1.5%
 
15 1564 1.5%
 
20 4155 4.0%
 

Maximum 5 values

ValueCountFrequency (%) 
15600 1 < 0.1%
 
13330 1 < 0.1%
 
13000 3 < 0.1%
 
12500 1 < 0.1%
 
11900 1 < 0.1%
 
ValueCountFrequency (%) 
0 35316 33.9%
 
50 4776 4.6%
 
40 4500 4.3%
 
30 4485 4.3%
 
20 4155 4.0%
 
60 3316 3.2%
 
100 3218 3.1%
 
70 2734 2.6%
 
80 2550 2.5%
 
90 2029 2.0%
 
Other values (557) 36953 35.5%
 

Quantile statistics

Minimum0
5-th percentile0
Q10
Median40
Q3150
95-th percentile970
Maximum15600
Range15600
Interquartile range150

Descriptive statistics

Standard deviation485.1847646
Coef of variation2.462629386
Kurtosis83.98765517
Mean197.0189942
MAD246.5303134
Skewness6.789508531
Sum20496280
Variance235404.2558
Memory size812.8 KiB

ROAD_SURFACE
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Sealed
102007
Unsealed
 
2022
Unknown
 
3
ValueCountFrequency (%) 
Sealed 102007 98.1%
 
Unsealed 2022 1.9%
 
Unknown 3 < 0.1%
 
Max length8
Mean length6.038901492
Min length6
Contains digitsFalse
Contains spacesFalse
Contains charsTrue
Contains non-wordsFalse

ROAD_MARKINGS
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Centre Line
68388
No Marks
 
11582
Raised Island
 
9751
Other values (4)
14311
ValueCountFrequency (%) 
Centre Line 68388 65.7%
 
No Marks 11582 11.1%
 
Raised Island 9751 9.4%
 
Painted Island 8881 8.5%
 
No Passing Lines 3366 3.2%
 
Unknown 1310 1.3%
 
Ped Crossing 754 0.7%
 
Max length16
Mean length11.22822785
Min length7
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

NUM_LANES
Numeric

Distinct count9
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2.303993002
Minimum0
Maximum8
Zeros (%)0.7%
Mini histogram
Histogram
Histogram with fixed size bins (bins=9)

Minimum 5 values

ValueCountFrequency (%) 
0 694 0.7%
 
1 4227 4.1%
 
2 78938 75.9%
 
3 7379 7.1%
 
4 9974 9.6%
 

Maximum 5 values

ValueCountFrequency (%) 
8 91 0.1%
 
7 109 0.1%
 
6 962 0.9%
 
5 1658 1.6%
 
4 9974 9.6%
 
ValueCountFrequency (%) 
2 78938 75.9%
 
4 9974 9.6%
 
3 7379 7.1%
 
1 4227 4.1%
 
5 1658 1.6%
 
6 962 0.9%
 
0 694 0.7%
 
7 109 0.1%
 
8 91 0.1%
 

Quantile statistics

Minimum0
5-th percentile2
Q12
Median2
Q32
95-th percentile4
Maximum8
Range8
Interquartile range0

Descriptive statistics

Standard deviation0.8822779218
Coef of variation0.3829342889
Kurtosis5.449883852
Mean2.303993002
MAD0.5980380877
Skewness1.962817698
Sum239689
Variance0.7784143314
Memory size812.8 KiB

CRASH_DIRN_DESC
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
35316
South
20978
North
20609
Other values (2)
27129
ValueCountFrequency (%) 
35316 33.9%
 
South 20978 20.2%
 
North 20609 19.8%
 
East 13574 13.0%
 
West 13555 13.0%
 
Max length5
Mean length3.381334589
Min length1
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

JUNCTION_TYPE
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Unknown
59178
T Type Junction
19958
X Type Junction
 
11632
Other values (4)
13264
ValueCountFrequency (%) 
Unknown 59178 56.9%
 
T Type Junction 19958 19.2%
 
X Type Junction 11632 11.2%
 
Driveway 7216 6.9%
 
Roundabout 5232 5.0%
 
Multi Rd Join 458 0.4%
 
Y Type Junction 358 0.3%
 
Max length15
Mean length9.703437404
Min length7
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

EASTING
Numeric

Distinct count64429
Unique (%)61.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1720853.876
Minimum0
Maximum2105750
Zeros (%)0.1%
Mini histogram
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 585605. 1171388.5 1185912.5 1187248.5 ... 2040139. 2059595. 2072695.5 2085852. 2105750. ], "bayesian blocks" binning strategy used)

Minimum 5 values

ValueCountFrequency (%) 
0 115 0.1%
 
1171210 1 < 0.1%
 
1171567 1 < 0.1%
 
1173432 1 < 0.1%
 
1175332 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2105750 1 < 0.1%
 
2089141 1 < 0.1%
 
2086323 1 < 0.1%
 
2085381 1 < 0.1%
 
2084302 1 < 0.1%
 
ValueCountFrequency (%) 
0 115 0.1%
 
1801553 39 < 0.1%
 
1759626 37 < 0.1%
 
1571132 35 < 0.1%
 
1751579 32 < 0.1%
 
1570399 30 < 0.1%
 
1745063 30 < 0.1%
 
1771345 27 < 0.1%
 
1754338 27 < 0.1%
 
1758140 26 < 0.1%
 
Other values (64419) 103634 99.6%
 

Quantile statistics

Minimum0
5-th percentile1383033.9
Q11713130.5
Median1758000.5
Q31794485.75
95-th percentile1923986.55
Maximum2105750
Range2105750
Interquartile range81355.25

Descriptive statistics

Standard deviation162352.3461
Coef of variation0.09434406272
Kurtosis14.8402544
Mean1720853.876
MAD109297.944
Skewness-2.430199982
Sum1.790238705e+11
Variance2.635828427e+10
Memory size812.8 KiB

INTERSECTION
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Unknown
68719
Intersection
34239
At Landmark
 
1074
ValueCountFrequency (%) 
Unknown 68719 66.1%
 
Intersection 34239 32.9%
 
At Landmark 1074 1.0%
 
Max length12
Mean length8.686894417
Min length7
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

CRASH_RP_SH
Categorical

Distinct count98
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
0
72511
1N
 
9273
2
 
3233
Other values (95)
19015
ValueCountFrequency (%) 
0 72511 69.7%
 
1N 9273 8.9%
 
2 3233 3.1%
 
1S 2764 2.7%
 
3 1776 1.7%
 
6 1741 1.7%
 
16 1141 1.1%
 
20 715 0.7%
 
5 646 0.6%
 
8 505 0.5%
 
Other values (88) 9727 9.4%
 
Max length3
Mean length1.60598662
Min length1
Contains digitsTrue
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

CRASH_SH_DESC
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
No
71669
Yes
32363
ValueCountFrequency (%) 
No 71669 68.9%
 
Yes 32363 31.1%
 

CRASH_YEAR
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
2017
39188
2016
37139
2018
27705
ValueCountFrequency (%) 
2017 39188 37.7%
 
2016 37139 35.7%
 
2018 27705 26.6%
 
Max length4
Mean length4
Min length4
Contains digitsTrue
Contains spacesFalse
Contains charsFalse
Contains non-wordsFalse

WEATHER_B
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Unknown
98977
Strong Wind
 
3229
Frost
 
1826
ValueCountFrequency (%) 
Unknown 98977 95.1%
 
Strong Wind 3229 3.1%
 
Frost 1826 1.8%
 
Max length11
Mean length7.089049523
Min length5
Contains digitsFalse
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

ROAD_LANE
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
2
89046
1
 
14258
O
 
674
ValueCountFrequency (%) 
2 89046 85.6%
 
1 14258 13.7%
 
O 674 0.6%
 
54 0.1%
 
Max length1
Mean length1
Min length1
Contains digitsTrue
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

STREET_LIGHT
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Unknown
64704
On
22805
None
 
11281
ValueCountFrequency (%) 
Unknown 64704 62.2%
 
On 22805 21.9%
 
None 11281 10.8%
 
Off 5242 5.0%
 
Max length7
Mean length5.377076284
Min length2
Contains digitsFalse
Contains spacesFalse
Contains charsTrue
Contains non-wordsFalse

DIRN_ROLE1_DESC
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
North
32652
South
30797
East
20598
Other values (2)
19985
ValueCountFrequency (%) 
North 32652 31.4%
 
South 30797 29.6%
 
East 20598 19.8%
 
West 19984 19.2%
 
0 1 < 0.1%
 
Max length5
Mean length4.60987004
Min length1
Contains digitsTrue
Contains spacesFalse
Contains charsTrue
Contains non-wordsFalse

SPD_LIM
Numeric

Distinct count12
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean67.07191057
Minimum10
Maximum110
Zeros (%)0.0%
Mini histogram
Histogram
Histogram with fixed size bins (bins=12)

Minimum 5 values

ValueCountFrequency (%) 
10 196 0.2%
 
15 3 < 0.1%
 
20 163 0.2%
 
30 915 0.9%
 
40 415 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
110 5 < 0.1%
 
100 30096 28.9%
 
90 133 0.1%
 
80 6294 6.1%
 
70 3540 3.4%
 
ValueCountFrequency (%) 
50 58145 55.9%
 
100 30096 28.9%
 
80 6294 6.1%
 
60 4127 4.0%
 
70 3540 3.4%
 
30 915 0.9%
 
40 415 0.4%
 
10 196 0.2%
 
20 163 0.2%
 
90 133 0.1%
 
Other values (2) 8 < 0.1%
 

Quantile statistics

Minimum10
5-th percentile50
Q150
Median50
Q3100
95-th percentile100
Maximum110
Range100
Interquartile range50

Descriptive statistics

Standard deviation22.68078823
Coef of variation0.3381562868
Kurtosis-1.350351701
Mean67.07191057
MAD20.87824299
Skewness0.569074449
Sum6977625
Variance514.4181546
Memory size812.8 KiB

CRASH_RP_NEWS_DESC
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
97195
Southbound
 
2901
Northbound
 
2816
Other values (2)
 
1120
ValueCountFrequency (%) 
0 97195 93.4%
 
Southbound 2901 2.8%
 
Northbound 2816 2.7%
 
Westbound 638 0.6%
 
Eastbound 482 0.5%
 
Max length10
Mean length1.580715549
Min length1
Contains digitsTrue
Contains spacesFalse
Contains charsTrue
Contains non-wordsFalse

CRASH_LOCN2
Categorical

Distinct count22302
Unique (%)21.4%
Missing (%)0.0%
Missing (n)0
SH 1N
 
749
SH 2
 
371
GREAT SOUTH ROAD
 
330
Other values (22299)
102582
ValueCountFrequency (%) 
SH 1N 749 0.7%
 
SH 2 371 0.4%
 
GREAT SOUTH ROAD 330 0.3%
 
SH 1S 278 0.3%
 
SH 3 256 0.2%
 
VICTORIA ST 232 0.2%
 
QUEEN ST 210 0.2%
 
CHURCH ST 199 0.2%
 
GREY ST 177 0.2%
 
GREAT NORTH ROAD 176 0.2%
 
Other values (22292) 101054 97.1%
 
Max length25
Mean length12.34498039
Min length4
Contains digitsTrue
Contains spacesTrue
Contains charsTrue
Contains non-wordsTrue

CRASH_RP_DISP
Numeric

Distinct count12533
Unique (%)12.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1830.941595
Minimum0
Maximum23849
Zeros (%)70.2%
Mini histogram
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000e+00 5.00000e-01 8.50000e+00 2.10000e+01 2.95000e+01 ... 1.84915e+04 1.84945e+04 2.05460e+04 2.18020e+04 2.38490e+04], "bayesian blocks" binning strategy used)

Minimum 5 values

ValueCountFrequency (%) 
0 73052 70.2%
 
1 9 < 0.1%
 
2 3 < 0.1%
 
3 2 < 0.1%
 
4 7 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
23849 1 < 0.1%
 
23088 3 < 0.1%
 
21812 1 < 0.1%
 
21792 1 < 0.1%
 
21789 1 < 0.1%
 
ValueCountFrequency (%) 
0 73052 70.2%
 
100 38 < 0.1%
 
30 34 < 0.1%
 
40 31 < 0.1%
 
1002 26 < 0.1%
 
20 23 < 0.1%
 
201 23 < 0.1%
 
200 22 < 0.1%
 
1254 22 < 0.1%
 
70 22 < 0.1%
 
Other values (12523) 30739 29.5%
 

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31244
95-th percentile11253.45
Maximum23849
Range23849
Interquartile range1244

Descriptive statistics

Standard deviation3814.27554
Coef of variation2.083231683
Kurtosis4.630236978
Mean1830.941595
MAD2702.301716
Skewness2.292777518
Sum190476516
Variance14548697.9
Memory size812.8 KiB

CRASH_RP_RS
Numeric

Distinct count455
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean99.61728122
Minimum0
Maximum1168
Zeros (%)73.9%
Mini histogram
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000e+00 5.0000e-01 1.5000e+00 2.5000e+00 3.5000e+00 ... 1.0775e+03 1.0870e+03 1.1440e+03 1.1625e+03 1.1680e+03], "bayesian blocks" binning strategy used)

Minimum 5 values

ValueCountFrequency (%) 
0 76863 73.9%
 
1 109 0.1%
 
2 15 < 0.1%
 
3 271 0.3%
 
4 42 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1168 116 0.1%
 
1157 18 < 0.1%
 
1145 22 < 0.1%
 
1143 2 < 0.1%
 
1127 14 < 0.1%
 
ValueCountFrequency (%) 
0 76863 73.9%
 
431 1394 1.3%
 
414 1113 1.1%
 
448 669 0.6%
 
7 484 0.5%
 
962 401 0.4%
 
10 375 0.4%
 
427 323 0.3%
 
17 320 0.3%
 
398 317 0.3%
 
Other values (445) 21773 20.9%
 

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q38
95-th percentile696
Maximum1168
Range1168
Interquartile range8

Descriptive statistics

Standard deviation236.3975953
Coef of variation2.373058092
Kurtosis6.328421841
Mean99.61728122
MAD156.7496519
Skewness2.639105936
Sum10363385
Variance55883.82306
Memory size812.8 KiB

CRASH_RP_DIRN_DESC
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
87537
Increasing
 
9094
Decreasing
 
7401
ValueCountFrequency (%) 
0 87537 84.1%
 
Increasing 9094 8.7%
 
Decreasing 7401 7.1%
 
Max length10
Mean length2.427012842
Min length1
Contains digitsTrue
Contains spacesFalse
Contains charsTrue
Contains non-wordsFalse

Correlations

Missing values

Sample

First rows

CR_RD_SIDE_RDCRASH_DIRN_DESCCRASH_DISTCRASH_LOCN1CRASH_LOCN2CRASH_RP_DIRN_DESCCRASH_RP_DISPCRASH_RP_NEWS_DESCCRASH_RP_RSCRASH_RP_SHCRASH_SEVCRASH_SH_DESCCRASH_YEARDIRN_ROLE1_DESCEASTINGFLAT_HILLHOLIDAYINTERSECTIONINTSN_MIDBLOCKJUNCTION_TYPELG_REGION_DESCLIGHTMULTI_VEHNORTHINGNUM_LANESOUTDTD_LOCN_DESCROAD_CHARACTERROAD_CURVATUREROAD_LANEROAD_MARKINGSROAD_SURFACEROAD_WETSPD_LIMSTREET_LIGHTTRAFFIC_CTRLURBANWEATHER_AWEATHER_B
01.0West40KERIKERI INLET ROADPA ROAD00000FNo2017East1688160FlatChristmas/New YearUnknownMid BlockUnknownNorthlandDarkVehicle(s)+Pedestrian(s)61013682Current locationUnknownStraight Road2No Passing LinesSealedDry80OnN/AOpenroadFineUnknown
11.0South250ORURU ROADRYDER ROAD00000FNo2017South1642352FlatChristmas/New YearUnknownMid BlockUnknownNorthlandDarkVehicle(s)+Pedestrian(s)61266322Current locationUnknownStraight Road2Centre LineSealedDry100NoneN/AOpenroadFineUnknown
21.0West1470THORNTON ROADPOWDRELL ROAD00000FNo2017East1942531FlatChristmas/New YearUnknownMid BlockUnknownBay of PlentyOvercastMulti vehicle57941712Current locationUnknownModerate Curve2No Passing LinesSealedDry100NoneN/AOpenroadFineUnknown
31.0South790SH 75RIFLE RANGE CV0404601475FYes2017North1564498FlatNoneUnknownMid BlockUnknownCanterburyOvercastMulti vehicle51619432Current locationUnknownModerate Curve2Centre LineSealedWet100UnknownN/AOpenroadFineStrong Wind
41.0North170SH 8AIRPORT ROAD01196503108FYes2017North1313029FlatNoneUnknownMid BlockUnknownOtagoOvercastVehicle(s)+Pedestrian(s)49868652Current locationUnknownStraight Road2Centre LineSealedDry100UnknownN/AOpenroadFineUnknown
51.0South2470CROWN RANGE ROADCARDRONA VALLEY ROAD00000FNo2017South1282505FlatNoneUnknownMid BlockUnknownOtagoBright SunMulti vehicle50191002Current locationUnknownModerate Curve2Centre LineSealedDry100UnknownN/AOpenroadFineUnknown
61.00ARUNDEL RAKAIA GORGE ROADRANGITATA RIV BR NO200000FNo2017South1473725FlatNoneAt LandmarkMid BlockUnknownCanterburyOvercastSingle vehicle51605292Current locationBridgeStraight Road2Centre LineSealedDry100UnknownN/AOpenroadFineUnknown
71.0South900SH 1NBROADLANDS ON SBDIncreasing676706961NFYes2017North1871144FlatNoneUnknownMid BlockUnknownWaikatoBright SunVehicle(s)+Cyclist(s) only57144472Current locationUnknownStraight Road2Centre LineSealedDry100UnknownN/AOpenroadFineUnknown
81.00OTEHA VALLEY ROADCORNERSTONE DRIVE00000FNo2017West1752763FlatNoneIntersectionIntersectionT Type JunctionAucklandDarkSingle vehicle59348562Current locationUnknownStraight Road1Raised IslandSealedDry60OnGive Way SignUrbanFineUnknown
91.00SH 3OROUA ROAD01197304503FYes2017North1814920FlatNoneIntersectionIntersectionT Type JunctionManawatu/WanganuiOvercastMulti vehicle55379262Current locationUnknownStraight Road2Centre LineSealedWet100UnknownGive Way SignOpenroadLight RainUnknown

Last rows

CR_RD_SIDE_RDCRASH_DIRN_DESCCRASH_DISTCRASH_LOCN1CRASH_LOCN2CRASH_RP_DIRN_DESCCRASH_RP_DISPCRASH_RP_NEWS_DESCCRASH_RP_RSCRASH_RP_SHCRASH_SEVCRASH_SH_DESCCRASH_YEARDIRN_ROLE1_DESCEASTINGFLAT_HILLHOLIDAYINTERSECTIONINTSN_MIDBLOCKJUNCTION_TYPELG_REGION_DESCLIGHTMULTI_VEHNORTHINGNUM_LANESOUTDTD_LOCN_DESCROAD_CHARACTERROAD_CURVATUREROAD_LANEROAD_MARKINGSROAD_SURFACEROAD_WETSPD_LIMSTREET_LIGHTTRAFFIC_CTRLURBANWEATHER_AWEATHER_B
1040221.0North790SH 3MT MESSENGER TNL0483601763NYes2018South1738464HillEasterUnknownMid BlockUnknownTaranakiOvercastSingle vehicle56945042Current locationUnknownModerate Curve2Centre LineSealedWet100UnknownN/AOpenroadLight RainUnknown
1040231.00FINLAYSON AVENUEROSCOMMON ROAD00000NNo2018North1765759FlatNoneIntersectionIntersectionT Type JunctionAucklandDarkMulti vehicle59011442Current locationUnknownStraight Road2Centre LineSealedDry60OnNilUrbanFineUnknown
1040241.0South70CORONATION ROADTAYLOR ROAD00000NNo2018South1759224FlatNoneUnknownMid BlockUnknownAucklandBright SunVehicle(s)+Pedestrian(s)59096792Current locationUnknownStraight Road2Centre LineSealedDry50UnknownN/AUrbanFineUnknown
1040251.0East60DELL AVENUEORAKEI ROAD00000NNo2018East1760945FlatNoneUnknownMid BlockUnknownAucklandBright SunMulti vehicle59179302Current locationUnknownStraight Road2Centre LineSealedDry50UnknownN/AUrbanFineUnknown
1040261.0West40SH 73RANGIRIRI CRK BR07589019173NYes2018West1462679FlatNoneUnknownMid BlockUnknownWest CoastOvercastSingle vehicle52648762Current locationUnknownModerate Curve2Centre LineSealedDry100UnknownN/AOpenroadFineUnknown
1040271.0West100ALFRED STDASHWOOD ST00000NNo2018East1679203FlatNoneUnknownMid BlockUnknownNelson/MarlboroughDarkMulti vehicle54041162Current locationUnknownStraight Road2No MarksSealedDry50OnN/AUrbanFineUnknown
1040281.00DURHAM STSH 76Decreasing32800376NYes2018South1570406FlatNoneIntersectionIntersectionT Type JunctionCanterburyDarkMulti vehicle51783264Current locationUnknownStraight Road2Centre LineSealedDry50OnTraffic SignalUrbanFineUnknown
1040291.0East290DIP ROADGEORGIA LANE00000NNo2018North1716467HillNoneUnknownMid BlockUnknownNorthlandOvercastSingle vehicle60508612Current locationUnknownModerate Curve2Centre LineSealedWet50UnknownN/AUrbanLight RainUnknown
1040301.0South20FAIRWAY DRIVESH 200000NNo2018North1761848FlatNoneUnknownMid BlockT Type JunctionWellingtonOvercastMulti vehicle54383472Current locationUnknownModerate Curve2Centre LineSealedDry50UnknownNilUrbanFineUnknown
1040311.0South160ROSETTA ROADMENIN ROAD00000NNo2018North1766501FlatNoneUnknownMid BlockUnknownWellingtonDarkMulti vehicle54671882Current locationUnknownStraight Road2Centre LineSealedDry50OnN/AUrbanFineUnknown